package com.qingcheng.dao;

import com.qingcheng.pojo.goods.CategoryAndSpecCompose;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;


public interface CategoryAndSpecMapper extends Mapper<CategoryAndSpecCompose> {

    @Select("select ca.name categoryName,sp.* from tb_category ca,tb_spec sp\n" +
            "where ca.template_id in ( select template_id from tb_spec\n ) ")
    public List<CategoryAndSpecCompose> findCategortAndSpec();
}
